123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117 |
- -- UAP报表脚本(数量: 1张 生成时间:2019年8月21日 19:42)
- -- 1.错误日志查询( 1个视图,项目号U8CUSTDEF)
- -- "错误日志查询"
- -- 添加新的UAP报表
- -- 插入项目信息
- DELETE FROM uap_projects WHERE cProjectNum=N'U8CUSTDEF'
- INSERT INTO uap_projects(cProjectId,cProjectName,cProjectDescription,cCreater,cSub_Products,bOpened,dLastDate,bShared,iSharedType,dCreateDate,cProjectNum,iOrder)VALUES(N'65b883c7-3d78-4f16-ba03-326a852ac7c2',N'客户化',N'U8 UAP 客户化项目',N'demo',N'SA,',N'1',N'2019/8/21 18:57:15',N'0',N'0',N'2006/10/24 14:11:29',N'U8CUSTDEF',N'1')
- GO
- -- UAP报表数据报表级基础信息
- DELETE FROM UAP_Report WHERE ID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a'
- INSERT INTO UAP_Report(ID,FilterID,DataSourceID,FunctionName,Description,ProjectID,SubID,ClassName,FilterClass,bVB,bSystem,Creator,CreatedTime,bPublished,HelpFileName,HelpIndex,HelpKeyWord,bHadUpgradedFrom861,MappingMenuId,RootReportId,CanSaveAs,DataSourceIdExtended,bUsingReport4MenuId,IsNeedBak)VALUES(N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a',N'7EE838E9-F251-46A4-8853-072868EC69E5',N'c643043a-03e0-48b9-9320-61501317cef7',N'Function1',N'',N'U8CUSTDEF',N'SA',N'Report.ErrorReport,Report',N'',N'0',N'0',N'demo',N'2019/8/21 17:25:56',N'0',N'',N'',N'',N'1',N'SARPT213639',NULL,N'1',NULL,N'1',NULL)
- GO
- DELETE FROM UAP_Report_Lang WHERE ReportID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a' AND LocaleID=N'en-US'
- INSERT INTO UAP_Report_Lang(ReportID,LocaleID,Name,Description,NeedExpand)VALUES(N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a',N'en-US',N'错误日志查询',NULL,N'0')
- DELETE FROM UAP_Report_Lang WHERE ReportID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a' AND LocaleID=N'zh-CN'
- INSERT INTO UAP_Report_Lang(ReportID,LocaleID,Name,Description,NeedExpand)VALUES(N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a',N'zh-CN',N'错误日志查询',NULL,N'0')
- DELETE FROM UAP_Report_Lang WHERE ReportID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a' AND LocaleID=N'zh-TW'
- INSERT INTO UAP_Report_Lang(ReportID,LocaleID,Name,Description,NeedExpand)VALUES(N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a',N'zh-TW',N'错误日志查询',NULL,N'0')
- GO
- DELETE FROM UAP_ReportUserView WHERE ReportID=N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a'
- INSERT INTO UAP_ReportUserView(UserID,ReportID,ViewID)VALUES(N'demo',N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a',N'fcb05799-1092-4653-b7e5-271e59d452a2')
- GO
- -- UAP报表数据源:可能包含进行扩展后的BO对象
- DELETE FROM BD_BusinessObjects WHERE MetaID=N'c643043a-03e0-48b9-9320-61501317cef7'
- INSERT INTO BD_BusinessObjects(MetaID,Name,ProjectNo,SubNo,MetaInfo,Description,Catagory,VoucherType,bCompoundBO)VALUES(N'c643043a-03e0-48b9-9320-61501317cef7',N'错误日志查询(2019-08-21 下午 19:43:01)',N'U8CUSTDEF',N'SA',N'<BusinessObject name="错误日志查询" description="错误日志查询" descriptionCN="错误日志查询" descriptionTW="" descriptionUS="" entityID="">
- <Function type="Query" name="Function1" description="" descriptionCN="" descriptionTW="" descriptionUS="">
- <DataQueries><Query name="Query1" querist="CustomQuerist" description="" descriptionCN="" descriptionTW="" descriptionUS="">
- <Distinct value="False"/><ResultTable name="ResultTable1" description="" descriptionCN="" descriptionTW="" descriptionUS="" >
- <Column name="operdate" dataType="DateTime" description="日志时间" descriptionCN="日志时间" descriptionTW="" descriptionUS=""/>
- <Column name="opertype" dataType="String" description="操作类型" descriptionCN="操作类型" descriptionTW="" descriptionUS=""/>
- <Column name="msg" dataType="String" description="错误内容" descriptionCN="错误内容" descriptionTW="" descriptionUS=""/>
- </ResultTable><Content dllType="DotNet" typeInfo="Report.ErrorReport,Report"/>
- </Query></DataQueries></Function></BusinessObject>',N'错误日志查询',N'ReportBO',N'',N'0')
- GO
- -- UAP报表过滤条件
- DELETE FROM flt_DefineMeta_Cust WHERE FilterId=N'7EE838E9-F251-46A4-8853-072868EC69E5'
- DELETE FROM flt_DefineMeta_Cache WHERE FilterId=N'7EE838E9-F251-46A4-8853-072868EC69E5'
- DELETE FROM flt_DefineMeta_Base WHERE FilterID=N'7EE838E9-F251-46A4-8853-072868EC69E5'
- INSERT INTO flt_DefineMeta_Base(FilterID,ProjectNO,XMLExpression,SubNO,FilterName,FilterDesc,IsUpgrade,bLocked,cLockedBy,PersonItems)VALUES(N'7EE838E9-F251-46A4-8853-072868EC69E5',N'U8CUSTDEF',N'<root canceladvanceitemlist="" title="" behaviorclass="" hasgroupby="0" hasadvance="0" cancelseconddev="0"><filter><items><item projectno="U8CUSTDEF" position="10" name="stsrtdate" reftype="2" refid="" commonlogic="uq" pointbit="-1" fieldname="operdate" fieldclass="" iscommon="1" mustinput="1" rangeinput="1" multselect="0" allowupdatecomparelogic="1" orlogic="0" showstyle="0" ispara="0" displayinportalview="0" autodisplaytext="0" isfacilitycondition="0" isjoinfulltextquery="0" format="" caption="" commoncaption="" defaultvalue="" descvalue="Null[####]Null" groupnum="" returnfield=""/></items></filter></root>
- ',N'SA',NULL,NULL,N'0',NULL,NULL,NULL)
- GO
- DELETE FROM flt_DefineMeta_Lang WHERE FilterID=N'7EE838E9-F251-46A4-8853-072868EC69E5' AND LocaleID=N'zh-cn'
- INSERT INTO flt_DefineMeta_Lang(FilterID,LocaleID,XMLExpression,SubNO,ProjectNO,Title)VALUES(N'7EE838E9-F251-46A4-8853-072868EC69E5',N'zh-cn',N'<root><items><item caption="日志时间" columncaption="" enum="" name="stsrtdate"/></items></root>',N'SA',N'U8CUSTDEF',NULL)
- DELETE FROM flt_DefineMeta_Lang WHERE FilterID=N'7EE838E9-F251-46A4-8853-072868EC69E5' AND LocaleID=N'zh-tw'
- INSERT INTO flt_DefineMeta_Lang(FilterID,LocaleID,XMLExpression,SubNO,ProjectNO,Title)VALUES(N'7EE838E9-F251-46A4-8853-072868EC69E5',N'zh-tw',N'<root><items><item name="stsrtdate"/></items></root>',N'SA',N'U8CUSTDEF',NULL)
- DELETE FROM flt_DefineMeta_Lang WHERE FilterID=N'7EE838E9-F251-46A4-8853-072868EC69E5' AND LocaleID=N'en-us'
- INSERT INTO flt_DefineMeta_Lang(FilterID,LocaleID,XMLExpression,SubNO,ProjectNO,Title)VALUES(N'7EE838E9-F251-46A4-8853-072868EC69E5',N'en-us',N'<root><items><item name="stsrtdate"/></items></root>',N'SA',N'U8CUSTDEF',NULL)
- GO
- -- UAP报表添加新的视图
- -- UAP报表视图级基础信息
- DELETE FROM UAP_ReportView WHERE ID=N'fcb05799-1092-4653-b7e5-271e59d452a2'
- INSERT INTO UAP_ReportView(ID,ReportID,ViewType,Columns,BlandScape,GroupSchemas,PageMargins,PaperType,bSystem,LevelExpend,ViewClass,RowsCount,bShowDetail,PageSetting,Selfaction,PreservedField,CanSaveDefaultFormat,FontColorStyleId,cvieworder,bclassicrptview,reportmergecell)VALUES(N'fcb05799-1092-4653-b7e5-271e59d452a2',N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a',N'1',N'A4@#$0',N'0',NULL,N'80,80,80,80',N'9',N'0',NULL,N'',N'500',N'1',NULL,NULL,NULL,N'0',NULL,N'0',N'0',N'0')
- GO
- DELETE FROM UAP_ReportView_Lang WHERE ViewID=N'fcb05799-1092-4653-b7e5-271e59d452a2' AND LocaleID=N'en-US'
- INSERT INTO UAP_ReportView_Lang(ViewID,LocaleID,Name,bSavedDirectly)VALUES(N'fcb05799-1092-4653-b7e5-271e59d452a2',N'en-US',N'错误日志查询',NULL)
- DELETE FROM UAP_ReportView_Lang WHERE ViewID=N'fcb05799-1092-4653-b7e5-271e59d452a2' AND LocaleID=N'zh-CN'
- INSERT INTO UAP_ReportView_Lang(ViewID,LocaleID,Name,bSavedDirectly)VALUES(N'fcb05799-1092-4653-b7e5-271e59d452a2',N'zh-CN',N'错误日志查询',N'1')
- DELETE FROM UAP_ReportView_Lang WHERE ViewID=N'fcb05799-1092-4653-b7e5-271e59d452a2' AND LocaleID=N'zh-TW'
- INSERT INTO UAP_ReportView_Lang(ViewID,LocaleID,Name,bSavedDirectly)VALUES(N'fcb05799-1092-4653-b7e5-271e59d452a2',N'zh-TW',N'错误日志查询',NULL)
- GO
- -- UAP报表视图的格式信息
- UPDATE UAP_ReportView SET ID=N'fcb05799-1092-4653-b7e5-271e59d452a2',Format=N'<Report Name="Report" Type="1" bPageByGroup="False" SolidGroup="" SolidGroupStyle="0" DesignWidth="0" PageRecords="500" ShowDetail="False" MustShowDetail="False" ViewClass="" FreeViewStyle="1" ReportHeaderOption="0" PrintProvider="0" CanSelectProvider="True" FixedRowsPerPage="0" SolidSort="False" FreeColorStyleID="" SupportDynamicColumn="False" DynamicColumnVisible="False" AllowGroup="True" AllowCross="True" bShowWhenZero="True" BorderStyle="0" BorderColor="-4144960" HelpName="" KeyIndex="" KeyWord="" RowFilter="AAEAAAD/////AQAAAAAAAAAMAgAAAGdVRklEQS5VOC5VQVAuU2VydmljZXMuUmVwb3J0RWxlbWVudHMsIFZlcnNpb249MS4wLjAuMCwgQ3VsdHVyZT1uZXV0cmFsLCBQdWJsaWNLZXlUb2tlbj03OWE0ZTdhZDU0ZWVhYmNhBQEAAAAuVUZJREEuVTguVUFQLlNlcnZpY2VzLlJlcG9ydEVsZW1lbnRzLlJvd0ZpbHRlcgIAAAANX0ZpbHRlclN0cmluZwhfTWFwS2V5cwEBAgAAAAYDAAAAAAkDAAAACw==" bAdjustPrintWidth="True" ReportColorSet="" FilterSource="EmptyColumn"><Section Name="ReportHeader" Type="ReportHeader" CaptionAlign="16" Visible="True" bHidden="False" KeepPos="False" Z_Order="0" FontName="宋体" FontSize="12" FontUnit="2" FontGdiCharSet="1" FontGdiVerticalFont="False" FontBold="False" FontItalic="False" FontStrikethout="False" FontUnderline="False" BackColor="-2167554" ForeColor="-16777216" BorderLeft="False" BorderTop="False" BorderRight="False" BorderBottom="False" BorderWidth="1" BorderColor="0" bControlAuth="True" bSupportLocate="True" bShowOnX="True" Level="0" bAutoSequence="False"><Control Name="HeaderLabel" Type="CommonLabel" CaptionAlign="32" Visible="True" bHidden="False" KeepPos="False" Z_Order="0" FontName="黑体" FontSize="20" FontUnit="3" FontGdiCharSet="0" FontGdiVerticalFont="False" FontBold="False" FontItalic="False" FontStrikethout="False" FontUnderline="False" BackColor="-1" ForeColor="-16777216" BorderLeft="False" BorderTop="False" BorderRight="False" BorderBottom="False" BorderWidth="1" BorderColor="0" bControlAuth="False" bSupportLocate="True" bShowOnX="True" LabelType="0" UserDefineItem="" bApplyColorStyle="False" InformationID="" CenterAlign="True" /></Section><Section Name="GridDetail" Type="GridDetail" CaptionAlign="16" Visible="True" bHidden="False" KeepPos="False" Z_Order="0" FontName="宋体" FontSize="12" FontUnit="2" FontGdiCharSet="1" FontGdiVerticalFont="False" FontBold="False" FontItalic="False" FontStrikethout="False" FontUnderline="False" BackColor="-2167554" ForeColor="-16777216" BorderLeft="False" BorderTop="False" BorderRight="False" BorderBottom="False" BorderWidth="1" BorderColor="0" bControlAuth="True" bSupportLocate="True" bShowOnX="True" Level="0"><Control Name="operdate" Type="GridDateTime" CaptionAlign="16" Visible="True" bHidden="False" KeepPos="False" Z_Order="0" FontName="宋体" FontSize="12" FontUnit="2" FontGdiCharSet="1" FontGdiVerticalFont="False" FontBold="False" FontItalic="False" FontStrikethout="False" FontUnderline="False" BackColor="-2167554" ForeColor="-16777216" BorderLeft="True" BorderTop="True" BorderRight="True" BorderBottom="True" BorderWidth="1" BorderColor="0" bControlAuth="True" bSupportLocate="True" bShowOnX="True" DataSource="operdate" FormatString="" Direction="0" Priority="0" EventType="0" bShowAtReal="False" DDLevel="2" ShowYear="True" ShowWeekRange="False" SupportSwitch="False" UserDefineItem="" bMergeCell="False" /><Control Name="opertype" Type="GridLabel" CaptionAlign="32" Visible="True" bHidden="False" KeepPos="False" Z_Order="0" FontName="宋体" FontSize="12" FontUnit="2" FontGdiCharSet="1" FontGdiVerticalFont="False" FontBold="False" FontItalic="False" FontStrikethout="False" FontUnderline="False" BackColor="-2167554" ForeColor="-16777216" BorderLeft="True" BorderTop="True" BorderRight="True" BorderBottom="True" BorderWidth="1" BorderColor="0" bControlAuth="True" bSupportLocate="True" bShowOnX="True" DataSource="opertype" Direction="0" Priority="0" LabelType="1" EventType="0" bShowAtReal="False" UserDefineItem="" bMergeCell="False" /><Control Name="msg" Type="GridLabel" CaptionAlign="32" Visible="True" bHidden="False" KeepPos="False" Z_Order="0" FontName="宋体" FontSize="12" FontUnit="2" FontGdiCharSet="1" FontGdiVerticalFont="False" FontBold="False" FontItalic="False" FontStrikethout="False" FontUnderline="False" BackColor="-2167554" ForeColor="-16777216" BorderLeft="True" BorderTop="True" BorderRight="True" BorderBottom="True" BorderWidth="1" BorderColor="0" bControlAuth="True" bSupportLocate="True" bShowOnX="True" DataSource="msg" Direction="0" Priority="0" LabelType="1" EventType="0" bShowAtReal="False" UserDefineItem="" bMergeCell="False" /></Section><Section Name="PageFooter" Type="PageFooter" CaptionAlign="16" Visible="True" bHidden="False" KeepPos="False" Z_Order="0" FontName="宋体" FontSize="9" FontUnit="3" FontGdiCharSet="0" FontGdiVerticalFont="False" FontBold="False" FontItalic="False" FontStrikethout="False" FontUnderline="False" BackColor="-1" ForeColor="-16777216" BorderLeft="False" BorderTop="False" BorderRight="False" BorderBottom="False" BorderWidth="1" BorderColor="0" bControlAuth="True" bSupportLocate="True" bShowOnX="True" Level="0" bAutoSequence="False"><Control Name="Drawing143730" Type="CommonLabel" CaptionAlign="64" Visible="True" bHidden="False" KeepPos="False" Z_Order="0" FontName="宋体" FontSize="9" FontUnit="3" FontGdiCharSet="0" FontGdiVerticalFont="False" FontBold="False" FontItalic="False" FontStrikethout="False" FontUnderline="False" BackColor="-1" ForeColor="-16777216" BorderLeft="False" BorderTop="False" BorderRight="False" BorderBottom="False" BorderWidth="1" BorderColor="0" bControlAuth="False" bSupportLocate="True" bShowOnX="True" LabelType="3" UserDefineItem="" bApplyColorStyle="False" InformationID="" CenterAlign="False" /><Control Name="Drawing143731" Type="Expression" CaptionAlign="16" Visible="True" bHidden="False" KeepPos="False" Z_Order="0" FontName="宋体" FontSize="9" FontUnit="3" FontGdiCharSet="0" FontGdiVerticalFont="False" FontBold="False" FontItalic="False" FontStrikethout="False" FontUnderline="False" BackColor="-1" ForeColor="-16777216" BorderLeft="False" BorderTop="False" BorderRight="False" BorderBottom="False" BorderWidth="1" BorderColor="0" bControlAuth="False" bSupportLocate="True" bShowOnX="True" Formula="getcopritionname()" FormulaType="0" Precision="0" FormatString="" bDateTime="False" /><Control Name="Drawing143732" Type="CommonLabel" CaptionAlign="64" Visible="True" bHidden="False" KeepPos="False" Z_Order="0" FontName="宋体" FontSize="9" FontUnit="3" FontGdiCharSet="0" FontGdiVerticalFont="False" FontBold="False" FontItalic="False" FontStrikethout="False" FontUnderline="False" BackColor="-1" ForeColor="-16777216" BorderLeft="False" BorderTop="False" BorderRight="False" BorderBottom="False" BorderWidth="1" BorderColor="0" bControlAuth="False" bSupportLocate="True" bShowOnX="True" LabelType="3" UserDefineItem="" bApplyColorStyle="False" InformationID="" CenterAlign="False" /><Control Name="Drawing143733" Type="Expression" CaptionAlign="16" Visible="True" bHidden="False" KeepPos="False" Z_Order="0" FontName="宋体" FontSize="9" FontUnit="3" FontGdiCharSet="0" FontGdiVerticalFont="False" FontBold="False" FontItalic="False" FontStrikethout="False" FontUnderline="False" BackColor="-1" ForeColor="-16777216" BorderLeft="False" BorderTop="False" BorderRight="False" BorderBottom="False" BorderWidth="1" BorderColor="0" bControlAuth="False" bSupportLocate="True" bShowOnX="True" Formula="getusername()" FormulaType="0" Precision="0" FormatString="" bDateTime="False" /><Control Name="Drawing143736" Type="CommonLabel" CaptionAlign="64" Visible="True" bHidden="False" KeepPos="False" Z_Order="0" FontName="宋体" FontSize="9" FontUnit="3" FontGdiCharSet="0" FontGdiVerticalFont="False" FontBold="False" FontItalic="False" FontStrikethout="False" FontUnderline="False" BackColor="-1" ForeColor="-16777216" BorderLeft="False" BorderTop="False" BorderRight="False" BorderBottom="False" BorderWidth="1" BorderColor="0" bControlAuth="False" bSupportLocate="True" bShowOnX="True" LabelType="3" UserDefineItem="" bApplyColorStyle="False" InformationID="" CenterAlign="False" /><Control Name="Drawing143734" Type="CommonLabel" CaptionAlign="64" Visible="True" bHidden="False" KeepPos="False" Z_Order="0" FontName="宋体" FontSize="9" FontUnit="3" FontGdiCharSet="0" FontGdiVerticalFont="False" FontBold="False" FontItalic="False" FontStrikethout="False" FontUnderline="False" BackColor="-1" ForeColor="-16777216" BorderLeft="False" BorderTop="False" BorderRight="False" BorderBottom="False" BorderWidth="1" BorderColor="0" bControlAuth="False" bSupportLocate="True" bShowOnX="True" LabelType="3" UserDefineItem="" bApplyColorStyle="False" InformationID="" CenterAlign="False" /><Control Name="Drawing143737" Type="Expression" CaptionAlign="16" Visible="True" bHidden="False" KeepPos="False" Z_Order="0" FontName="宋体" FontSize="9" FontUnit="3" FontGdiCharSet="0" FontGdiVerticalFont="False" FontBold="False" FontItalic="False" FontStrikethout="False" FontUnderline="False" BackColor="-1" ForeColor="-16777216" BorderLeft="False" BorderTop="False" BorderRight="False" BorderBottom="False" BorderWidth="1" BorderColor="0" bControlAuth="False" bSupportLocate="True" bShowOnX="True" Formula="page()" FormulaType="0" Precision="0" FormatString="" bDateTime="False" /><Control Name="Drawing143738" Type="CommonLabel" CaptionAlign="64" Visible="True" bHidden="False" KeepPos="False" Z_Order="0" FontName="宋体" FontSize="9" FontUnit="3" FontGdiCharSet="0" FontGdiVerticalFont="False" FontBold="False" FontItalic="False" FontStrikethout="False" FontUnderline="False" BackColor="-1" ForeColor="-16777216" BorderLeft="False" BorderTop="False" BorderRight="False" BorderBottom="False" BorderWidth="1" BorderColor="0" bControlAuth="False" bSupportLocate="True" bShowOnX="True" LabelType="3" UserDefineItem="" bApplyColorStyle="False" InformationID="" CenterAlign="False" /><Control Name="Drawing143735" Type="Expression" CaptionAlign="16" Visible="True" bHidden="False" KeepPos="False" Z_Order="0" FontName="宋体" FontSize="9" FontUnit="3" FontGdiCharSet="0" FontGdiVerticalFont="False" FontBold="False" FontItalic="False" FontStrikethout="False" FontUnderline="False" BackColor="-1" ForeColor="-16777216" BorderLeft="False" BorderTop="False" BorderRight="False" BorderBottom="False" BorderWidth="1" BorderColor="0" bControlAuth="False" bSupportLocate="True" bShowOnX="True" Formula="date()" FormulaType="0" Precision="0" FormatString="" bDateTime="False" /><Control Name="Drawing143739" Type="Expression" CaptionAlign="16" Visible="True" bHidden="False" KeepPos="False" Z_Order="0" FontName="宋体" FontSize="9" FontUnit="3" FontGdiCharSet="0" FontGdiVerticalFont="False" FontBold="False" FontItalic="False" FontStrikethout="False" FontUnderline="False" BackColor="-1" ForeColor="-16777216" BorderLeft="False" BorderTop="False" BorderRight="False" BorderBottom="False" BorderWidth="1" BorderColor="0" bControlAuth="False" bSupportLocate="True" bShowOnX="True" Formula="pages()" FormulaType="0" Precision="0" FormatString="" bDateTime="False" /><Control Name="Drawing143740" Type="CommonLabel" CaptionAlign="64" Visible="True" bHidden="False" KeepPos="False" Z_Order="0" FontName="宋体" FontSize="9" FontUnit="3" FontGdiCharSet="0" FontGdiVerticalFont="False" FontBold="False" FontItalic="False" FontStrikethout="False" FontUnderline="False" BackColor="-1" ForeColor="-16777216" BorderLeft="False" BorderTop="False" BorderRight="False" BorderBottom="False" BorderWidth="1" BorderColor="0" bControlAuth="False" bSupportLocate="True" bShowOnX="True" LabelType="3" UserDefineItem="" bApplyColorStyle="False" InformationID="" CenterAlign="False" /></Section><DataSource><Column Name="operdate" Type="DateTime" /><Column Name="opertype" Type="String" /><Column Name="msg" Type="String" /></DataSource></Report>',RuntimeFormat=N'<RuntimeFormat Id=""><RuntimeFormatGroupFormat Id="00000000-0000-0000-0000-000000000001"><RuntimeFormatGroupStyle IsFoldRow="False" Id="Plane.WithDetail"><RuntimeFormatGroupLevel Id="1"><RuntimeFormatGridColumn Width="92" TextHAlign="1" IsVisible="True" Position="0" IsMerge="False" Id="operdate" /><RuntimeFormatGridColumn Width="150" TextHAlign="1" IsVisible="True" Position="1" IsMerge="False" Id="opertype" /><RuntimeFormatGridColumn Width="447" TextHAlign="1" IsVisible="True" Position="2" IsMerge="False" Id="msg" /></RuntimeFormatGroupLevel></RuntimeFormatGroupStyle></RuntimeFormatGroupFormat></RuntimeFormat>',Chartstring=N'' WHERE ID=N'fcb05799-1092-4653-b7e5-271e59d452a2'
- GO
- UPDATE UAP_ReportView_Lang SET ViewID=N'fcb05799-1092-4653-b7e5-271e59d452a2',LocaleID=N'en-US',Format=N'<Report><Section Name="ReportHeader" Type="ReportHeader" Height="140" Caption="报表标题区" IdentityCaption=""><Control Name="HeaderLabel" Type="CommonLabel" X="100" Y="40" Width="280" Height="80" Caption="错误日志查询" IdentityCaption="" /></Section><Section Name="GridDetail" Type="GridDetail" Height="140" Caption="明细区" IdentityCaption=""><Control Name="operdate" Type="GridDateTime" X="2" Y="32" Width="96" Height="24" Caption="日志时间" IdentityCaption="" /><Control Name="opertype" Type="GridLabel" X="98" Y="32" Width="156" Height="24" Caption="操作类型" IdentityCaption="" /><Control Name="msg" Type="GridLabel" X="254" Y="32" Width="466" Height="24" Caption="错误内容" IdentityCaption="" /></Section><Section Name="PageFooter" Type="PageFooter" Height="140" Caption="页脚区" IdentityCaption=""><Control Name="Drawing143730" Type="CommonLabel" X="9" Y="40" Width="40" Height="20" Caption="单位:" IdentityCaption="单位:" /><Control Name="Drawing143731" Type="Expression" X="53" Y="40" Width="164" Height="20" Caption="GetCopritionName()" IdentityCaption="GetCopritionName()" /><Control Name="Drawing143732" Type="CommonLabel" X="268" Y="40" Width="54" Height="20" Caption="制表人:" IdentityCaption="制表人:" /><Control Name="Drawing143733" Type="Expression" X="324" Y="40" Width="87" Height="20" Caption="GetUserName()" IdentityCaption="GetUserName()" /><Control Name="Drawing143736" Type="CommonLabel" X="427" Y="62" Width="106" Height="20" Caption="【用友】 第" IdentityCaption="【用友】 第" /><Control Name="Drawing143734" Type="CommonLabel" X="493" Y="40" Width="66" Height="20" Caption="打印日期:" IdentityCaption="打印日期:" /><Control Name="Drawing143737" Type="Expression" X="535" Y="62" Width="22" Height="20" Caption="page()" IdentityCaption="page()" /><Control Name="Drawing143738" Type="CommonLabel" X="559" Y="62" Width="45" Height="20" Caption="页,共" IdentityCaption="页,共" /><Control Name="Drawing143735" Type="Expression" X="565" Y="40" Width="84" Height="20" Caption="Date()" IdentityCaption="Date()" /><Control Name="Drawing143739" Type="Expression" X="606" Y="62" Width="23" Height="20" Caption="pages()" IdentityCaption="pages()" /><Control Name="Drawing143740" Type="CommonLabel" X="630" Y="62" Width="19" Height="20" Caption="页" IdentityCaption="页" /></Section><DataSource><Column Name="operdate" Caption="日志时间" /><Column Name="opertype" Caption="操作类型" /><Column Name="msg" Caption="错误内容" /></DataSource></Report>' WHERE ViewID=N'fcb05799-1092-4653-b7e5-271e59d452a2' AND LocaleID=N'en-US'
- UPDATE UAP_ReportView_Lang SET ViewID=N'fcb05799-1092-4653-b7e5-271e59d452a2',LocaleID=N'zh-CN',Format=N'<Report><Section Name="ReportHeader" Type="ReportHeader" Height="140" Caption="报表标题区" IdentityCaption=""><Control Name="HeaderLabel" Type="CommonLabel" X="100" Y="40" Width="280" Height="80" Caption="错误日志查询" IdentityCaption="" /></Section><Section Name="GridDetail" Type="GridDetail" Height="140" Caption="明细区" IdentityCaption=""><Control Name="operdate" Type="GridDateTime" X="2" Y="32" Width="96" Height="24" Caption="日志时间" IdentityCaption="" /><Control Name="opertype" Type="GridLabel" X="98" Y="32" Width="156" Height="24" Caption="操作类型" IdentityCaption="" /><Control Name="msg" Type="GridLabel" X="254" Y="32" Width="466" Height="24" Caption="错误内容" IdentityCaption="" /></Section><Section Name="PageFooter" Type="PageFooter" Height="140" Caption="页脚区" IdentityCaption=""><Control Name="Drawing143730" Type="CommonLabel" X="9" Y="40" Width="40" Height="20" Caption="单位:" IdentityCaption="单位:" /><Control Name="Drawing143731" Type="Expression" X="53" Y="40" Width="164" Height="20" Caption="GetCopritionName()" IdentityCaption="GetCopritionName()" /><Control Name="Drawing143732" Type="CommonLabel" X="268" Y="40" Width="54" Height="20" Caption="制表人:" IdentityCaption="制表人:" /><Control Name="Drawing143733" Type="Expression" X="324" Y="40" Width="87" Height="20" Caption="GetUserName()" IdentityCaption="GetUserName()" /><Control Name="Drawing143736" Type="CommonLabel" X="427" Y="62" Width="106" Height="20" Caption="【用友】 第" IdentityCaption="【用友】 第" /><Control Name="Drawing143734" Type="CommonLabel" X="493" Y="40" Width="66" Height="20" Caption="打印日期:" IdentityCaption="打印日期:" /><Control Name="Drawing143737" Type="Expression" X="535" Y="62" Width="22" Height="20" Caption="page()" IdentityCaption="page()" /><Control Name="Drawing143738" Type="CommonLabel" X="559" Y="62" Width="45" Height="20" Caption="页,共" IdentityCaption="页,共" /><Control Name="Drawing143735" Type="Expression" X="565" Y="40" Width="84" Height="20" Caption="Date()" IdentityCaption="Date()" /><Control Name="Drawing143739" Type="Expression" X="606" Y="62" Width="23" Height="20" Caption="pages()" IdentityCaption="pages()" /><Control Name="Drawing143740" Type="CommonLabel" X="630" Y="62" Width="19" Height="20" Caption="页" IdentityCaption="页" /></Section><DataSource><Column Name="operdate" Caption="日志时间" /><Column Name="opertype" Caption="操作类型" /><Column Name="msg" Caption="错误内容" /></DataSource></Report>' WHERE ViewID=N'fcb05799-1092-4653-b7e5-271e59d452a2' AND LocaleID=N'zh-CN'
- UPDATE UAP_ReportView_Lang SET ViewID=N'fcb05799-1092-4653-b7e5-271e59d452a2',LocaleID=N'zh-TW',Format=N'<Report><Section Name="ReportHeader" Type="ReportHeader" Height="140" Caption="报表标题区" IdentityCaption=""><Control Name="HeaderLabel" Type="CommonLabel" X="100" Y="40" Width="280" Height="80" Caption="错误日志查询" IdentityCaption="" /></Section><Section Name="GridDetail" Type="GridDetail" Height="140" Caption="明细区" IdentityCaption=""><Control Name="operdate" Type="GridDateTime" X="2" Y="32" Width="96" Height="24" Caption="日志时间" IdentityCaption="" /><Control Name="opertype" Type="GridLabel" X="98" Y="32" Width="156" Height="24" Caption="操作类型" IdentityCaption="" /><Control Name="msg" Type="GridLabel" X="254" Y="32" Width="466" Height="24" Caption="错误内容" IdentityCaption="" /></Section><Section Name="PageFooter" Type="PageFooter" Height="140" Caption="页脚区" IdentityCaption=""><Control Name="Drawing143730" Type="CommonLabel" X="9" Y="40" Width="40" Height="20" Caption="单位:" IdentityCaption="单位:" /><Control Name="Drawing143731" Type="Expression" X="53" Y="40" Width="164" Height="20" Caption="GetCopritionName()" IdentityCaption="GetCopritionName()" /><Control Name="Drawing143732" Type="CommonLabel" X="268" Y="40" Width="54" Height="20" Caption="制表人:" IdentityCaption="制表人:" /><Control Name="Drawing143733" Type="Expression" X="324" Y="40" Width="87" Height="20" Caption="GetUserName()" IdentityCaption="GetUserName()" /><Control Name="Drawing143736" Type="CommonLabel" X="427" Y="62" Width="106" Height="20" Caption="【用友】 第" IdentityCaption="【用友】 第" /><Control Name="Drawing143734" Type="CommonLabel" X="493" Y="40" Width="66" Height="20" Caption="打印日期:" IdentityCaption="打印日期:" /><Control Name="Drawing143737" Type="Expression" X="535" Y="62" Width="22" Height="20" Caption="page()" IdentityCaption="page()" /><Control Name="Drawing143738" Type="CommonLabel" X="559" Y="62" Width="45" Height="20" Caption="页,共" IdentityCaption="页,共" /><Control Name="Drawing143735" Type="Expression" X="565" Y="40" Width="84" Height="20" Caption="Date()" IdentityCaption="Date()" /><Control Name="Drawing143739" Type="Expression" X="606" Y="62" Width="23" Height="20" Caption="pages()" IdentityCaption="pages()" /><Control Name="Drawing143740" Type="CommonLabel" X="630" Y="62" Width="19" Height="20" Caption="页" IdentityCaption="页" /></Section><DataSource><Column Name="operdate" Caption="日志时间" /><Column Name="opertype" Caption="操作类型" /><Column Name="msg" Caption="错误内容" /></DataSource></Report>' WHERE ViewID=N'fcb05799-1092-4653-b7e5-271e59d452a2' AND LocaleID=N'zh-TW'
- GO
- -- 备份的原始视图格式
- -- 颜色字体方案
- -- 功能权限
- DELETE FROM UAP_ReportView_AuthId WHERE ViewGuid=N'fcb05799-1092-4653-b7e5-271e59d452a2'
- INSERT INTO UAP_ReportView_AuthId(ViewGuid,ReportGuid,ReportId,ViewIndex,IsReportApplyAuthControl)VALUES(N'fcb05799-1092-4653-b7e5-271e59d452a2',N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a',N'SA[__]f70c7f37-4fac-415a-a4fe-3acd58bcd33a_001',N'_fcb05799-1092-4653-b7e5-271e59d452a2',N'1')
- GO
- -- 视图的字段权限
- DELETE FROM AA_ColumnDic_Base WHERE cKey=N'fcb05799-1092-4653-b7e5-271e59d452a2' AND cFld=N'msg' AND LocaleID=N'en-US'
- INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'fcb05799-1092-4653-b7e5-271e59d452a2',N'msg',NULL,N'1',N'错误内容',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'en-US',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
- DELETE FROM AA_ColumnDic_Base WHERE cKey=N'fcb05799-1092-4653-b7e5-271e59d452a2' AND cFld=N'msg' AND LocaleID=N'zh-CN'
- INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'fcb05799-1092-4653-b7e5-271e59d452a2',N'msg',NULL,N'1',N'错误内容',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'zh-CN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
- DELETE FROM AA_ColumnDic_Base WHERE cKey=N'fcb05799-1092-4653-b7e5-271e59d452a2' AND cFld=N'msg' AND LocaleID=N'zh-TW'
- INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'fcb05799-1092-4653-b7e5-271e59d452a2',N'msg',NULL,N'1',N'错误内容',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'zh-TW',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
- DELETE FROM AA_ColumnDic_Base WHERE cKey=N'fcb05799-1092-4653-b7e5-271e59d452a2' AND cFld=N'operdate' AND LocaleID=N'en-US'
- INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'fcb05799-1092-4653-b7e5-271e59d452a2',N'operdate',NULL,N'1',N'日志时间',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'en-US',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
- DELETE FROM AA_ColumnDic_Base WHERE cKey=N'fcb05799-1092-4653-b7e5-271e59d452a2' AND cFld=N'operdate' AND LocaleID=N'zh-CN'
- INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'fcb05799-1092-4653-b7e5-271e59d452a2',N'operdate',NULL,N'1',N'日志时间',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'zh-CN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
- DELETE FROM AA_ColumnDic_Base WHERE cKey=N'fcb05799-1092-4653-b7e5-271e59d452a2' AND cFld=N'operdate' AND LocaleID=N'zh-TW'
- INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'fcb05799-1092-4653-b7e5-271e59d452a2',N'operdate',NULL,N'1',N'日志时间',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'zh-TW',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
- DELETE FROM AA_ColumnDic_Base WHERE cKey=N'fcb05799-1092-4653-b7e5-271e59d452a2' AND cFld=N'opertype' AND LocaleID=N'en-US'
- INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'fcb05799-1092-4653-b7e5-271e59d452a2',N'opertype',NULL,N'1',N'操作类型',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'en-US',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
- DELETE FROM AA_ColumnDic_Base WHERE cKey=N'fcb05799-1092-4653-b7e5-271e59d452a2' AND cFld=N'opertype' AND LocaleID=N'zh-CN'
- INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'fcb05799-1092-4653-b7e5-271e59d452a2',N'opertype',NULL,N'1',N'操作类型',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'zh-CN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
- DELETE FROM AA_ColumnDic_Base WHERE cKey=N'fcb05799-1092-4653-b7e5-271e59d452a2' AND cFld=N'opertype' AND LocaleID=N'zh-TW'
- INSERT INTO AA_ColumnDic_Base(cKey,cFld,cQryField,iColPos,cCaption,cCaptionPar,bFixed,bDisp,iColWidth,iAlign,cOrder,bLock,iMergeCols,bMustSel,bNeedSum,LocaleID,IsEnum,EnumType,EnumTypeString,bFilter,bMerge,CanModify,ReferType,bHideInColSet,cSumType,cProjectNO,cSubID,cPointBit,cFormat,cEditStyle,iFieldType,bExtended,EnumShowType,iLinkType,bMustInput,bCanModifyMustInput,bCanModifyOrder)VALUES(N'fcb05799-1092-4653-b7e5-271e59d452a2',N'opertype',NULL,N'1',N'操作类型',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'zh-TW',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'U8CUSTDEF',N'SA',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
- GO
- -- 门户菜单相关
- -- 联查功能
- -- 报表自定义事件
|